Dear All,
I've been renaming some of my tables with alter table. These tables were
created with a primary key so an implicit unique index is created on the
primary key field.
When I rename the table, the <old_table_name>_pkey is not renamed but the
key still appears to function normally (e.g. I can't insert two entries
with the same primary key).
Are they any instances (other than 'human' ones such as lack of clarity in
table names) where this might be a problem or can I safely ingnore the
discrepancy.
Cheers,
S.
+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ University College London |
| Tel. (0171) 878 4041 | 91 Riding House Street |
| Fax. (0171) 878 4040 | London, W1P 8BT, UNITED KINGDOM. |
+-------------------------+--------------------------------------+
| stuart@NOJUNK_ludwig.ucl.ac.uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+